Leibel S Community Champion

Overview

Overview

Roles	Member
Badges	33

About Me

About Me

Area of Expertise
About Me
How I Use Smartsheet
Linkedin
Twitter Page

Analytics

848

Posts

1,548

Visits

10.9k

Points

Oct 12, 2020

Join Date

Mar 7, 2025

Last Active

Reactions

• Promote 1

  1
• Insightful 42

  42
• Vote Up 247

  247
• Awesome 72

  72

• Activity
• Discussions6
• Comments842

• Re: Formula assistance - multi select column and a not blank column

  Leibel S

  02/05/25
  Did you want to check for either Live - Symposium or Live - Congress then you would need: =COUNTIFS([Format Type]:[Format Type], OR(HAS(@cell, "Live - Symposium"), HAS(@cell, "Live - C…
  1 ·

• Re: How to add varying months to varying dates?

  Leibel S

  01/30/25
  @S.Stone I see what happened here: the below should fix it =DATE(YEAR([Date Contract Executed]@row) + ROUNDDOWN(([Months Until Expiration]@row + MONTH([Date Contract Executed]@row)) / 12.00001, 0), R…
  2 ·

• Re: In need of a formula that takes the amount in the Children rows and divides by a Parent row total

  Leibel S

  01/07/25
  @Crystal Panning Try the below, it should work as a column formula too =IF(AND(PARENT([Merchant Revised Casepack Quantity]@row) > 0, [Merchant Revised Casepack Quantity]@row > 0), [Merchant Rev…
  1 ·

• Re: How to use Collect & Contains function to pull value from different sheet?

  Leibel S

  01/22/21
  See below =INDEX(COLLECT({Fire Extinguisher & Eye Wash Inspection Range 1}, {Fire Extinguisher & Eye Wash Inspection Range 2}, CONTAINS([Tracking No]@row, @cell)), 1)
  1 ·

• Re: "Week Starting" date from created date

  Leibel S

  03/29/22
  @Andrea Zenner =IF(WEEKDAY(Date@row) = 1, Date@row - 6, Date@row - (WEEKDAY(Date@row) - 2))
  2 ·

Next